CREATE VIEW [dbo].[vGiftsReceived] AS      
     SELECT  g.[OriginalTransaction],
                 g.[TransactionNumber],
                 g.[Fund],
                 g.[Campaign],
                 g.[Appeal],
                 DATEPART(year,g.[TransactionDate]) AS CalendarYear,  
                 g.[FiscalYear],
                 g.[ID],
                 g.[TransactionDate],
                 g.[DateReceived],     
                 CASE
                       WHEN (SELECT COUNT(v.OriginalTransaction) from vGiftHistoryBase v where g.OriginalTransaction = v.OriginalTransaction and g.ID = v.ID) > 1 then 'Split-' + g.GiftType
                       ELSE g.GiftType END AS GiftType,
                 g.[PaymentType] AS PaymentMethod,
                 g.[SolicitorID],  
                 g.[Amount],
                 g.MemorialNameText,
                 g.MemorialTributeType,
                 g.MemorialTributeMessage,
                 g.TributeNotificationContactID                                             
       FROM [dbo].[vGiftsReceivedBase] g
    GROUP BY  g.[OriginalTransaction],
             g.[TransactionNumber],
             g.[Fund],
             g.[Campaign],                 
             g.[Appeal],            
             g.[PaymentType],            
             g.[TransactionDate],
             g.[FiscalYear],
             g.[DateReceived],                 
             g.[ID],
             g.[GiftType],
             g.[SolicitorID],
             g.[Amount],   
             g.MemorialNameText,
             g.MemorialTributeType,
             g.MemorialTributeMessage,
             g.TributeNotificationContactID                           





GO